<%@page import="java.sql.*"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>日志查看</title>
</head>
<body>
<table>
<%
	Class.forName("com.mysql.jdbc.Driver");
	Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test","root","123456");
	Statement sql = conn.createStatement();
	ResultSet rs = sql.executeQuery("select * from log order by time");
	while(rs.next()){
	String name = rs.getString("name");
	String title = rs.getString("title");
	String content = rs.getString("content");
	String time = rs.getString("time");
%>
	<tr><td>名字:</td><td><%=name%></td></tr>
	<tr><td>标题:</td><td><%=title%></td></tr>
	<tr><td>内容:</td><td><%=content%></td></tr>
	<tr><td>时间:</td><td><%=time%></td></tr>
	<tr><td><HR style="FILTER: alpha(opacity=100,finishopacity=0,style=3)" width="80%" color=#987cb9 SIZE=3></td></tr>
	<% } %>
</table>
</body>
</html>